Details
- Tags
- untagged
- Owner
- TRANSFORMER
- Type
- table
- Package
- gitlab_snowflake
- Relation
- PROD.common.dim_date
- Approximate Size
- 818 KB
- Last Modified
- 2023-07-10 23:06UTC
- Row Count
- -1
| Column | Type | Description | Tests | More? |
|---|---|---|---|---|
date_id | NUMBER | UN | ||
date_day | DATE | |||
date_actual | DATE | |||
day_name | TEXT | |||
month_actual | NUMBER | |||
year_actual | NUMBER | |||
quarter_actual | NUMBER | |||
day_of_week | NUMBER | |||
first_day_of_week | DATE | |||
week_of_year | NUMBER | |||
day_of_month | NUMBER | |||
day_of_quarter | NUMBER | |||
day_of_year | NUMBER | |||
fiscal_year | NUMBER | |||
fiscal_quarter | TEXT | |||
day_of_fiscal_quarter | NUMBER | |||
day_of_fiscal_year | NUMBER | |||
month_name | TEXT | |||
first_day_of_month | DATE | |||
last_day_of_month | DATE | |||
first_day_of_year | DATE | |||
last_day_of_year | DATE | |||
first_day_of_quarter | DATE | |||
last_day_of_quarter | DATE | |||
first_day_of_fiscal_quarter | DATE | |||
last_day_of_fiscal_quarter | DATE | |||
first_day_of_fiscal_year | DATE | |||
last_day_of_fiscal_year | DATE | |||
week_of_fiscal_year | NUMBER | |||
month_of_fiscal_year | NUMBER | |||
last_day_of_week | DATE | |||
quarter_name | TEXT | |||
fiscal_quarter_name | TEXT | |||
fiscal_quarter_name_fy | TEXT | |||
fiscal_quarter_number_absolute | NUMBER | |||
fiscal_month_name | TEXT | |||
fiscal_month_name_fy | TEXT | |||
holiday_desc | TEXT | |||
is_holiday | BOOLEAN | |||
last_month_of_fiscal_quarter | DATE | |||
is_first_day_of_last_month_of_fiscal_quarter | BOOLEAN | |||
last_month_of_fiscal_year | DATE | |||
is_first_day_of_last_month_of_fiscal_year | BOOLEAN | |||
snapshot_date_fpa | DATE | |||
snapshot_date_billings | DATE | |||
days_in_month_count | NUMBER | |||
week_of_month_normalised | NUMBER | |||
day_of_fiscal_quarter_normalised | NUMBER | |||
week_of_fiscal_quarter_normalised | NUMBER | |||
day_of_fiscal_year_normalised | NUMBER | |||
is_first_day_of_fiscal_quarter_week | NUMBER | |||
days_until_last_day_of_month | NUMBER | |||
current_date_actual | DATE | |||
current_fiscal_year | NUMBER | |||
current_first_day_of_fiscal_year | DATE | |||
current_fiscal_quarter_name_fy | TEXT | |||
current_first_day_of_month | DATE | |||
created_by | TEXT | |||
updated_by | TEXT | |||
model_created_date | DATE | |||
model_updated_date | DATE | |||
dbt_updated_at | TIMESTAMP_LTZ | |||
dbt_created_at | TIMESTAMP_LTZ |
{{ config({
"alias": "dim_date"
}) }}
WITH dates AS (
SELECT
{{ dbt_utils.star(
from=ref('prep_date'),
except=['CREATED_BY','UPDATED_BY','MODEL_CREATED_DATE','MODEL_UPDATED_DATE','DBT_UPDATED_AT','DBT_CREATED_AT']
)
}}
FROM {{ ref('prep_date') }}
), final AS (
SELECT
{{ get_date_id('date_actual') }} AS date_id,
*
FROM dates
)
{{ dbt_audit(
cte_ref="final",
created_by="@msendal",
updated_by="@pempey",
created_date="2020-06-01",
updated_date="2023-01-09"
) }}